When using a lookup column in a custom list in SharePoint, you have the option to “enforce relationship behavior” where you can prevent items from the lookup list from being deleted once they are selected, or you can cause a cascade-delete action to occur